CREATE TABLE [dbo].[DISC_DistributorConfig]
(
[ID] [tinyint] NOT NULL IDENTITY(1, 1),
[distID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[name] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[disturl] [varchar] (254) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[notifyurl] [varchar] (254) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sharedsecret] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[AllowedIPAddress] [varchar] (254) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[LocationDir] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DownloadURLDir] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DataPathDir] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PWDBName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PWServerDN] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MaxDownloadsReached] [varchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__DISC_Dist__MaxDo__231F2AE2] DEFAULT ('<br><br><br><font size="4" face="arial" color = "blue"><center><b>No more Downloads available for this item.<br><br>If this is an error, please contact Customer Support at 1-800-xxx-xxxx.</b></center></font>'),
[UsePW] [bit] NOT NULL CONSTRAINT [DF__DISC_Dist__UsePW__24134F1B] DEFAULT ('1'),
[AllowedWebStore] [varchar] (254) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Description] [nvarchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MaxLoanCount] [int] NULL,
[LinkExpires] [int] NULL,
[Deleted] [bit] NOT NULL CONSTRAINT [DF__DISC_Dist__Delet__4A8DFDBE] DEFAULT ((0)),
[DownloadExpired] [nvarchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__DISC_Dist__Downl__233504D2] DEFAULT ('')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DISC_DistributorConfig] ADD CONSTRAINT [PK_DISC_DistributorConfig] PRIMARY KEY CLUSTERED  ([ID]) WITH (FILLFACTOR=85) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [UIX_DISC_DistributorConfig_distID] ON [dbo].[DISC_DistributorConfig] ([distID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_DISC_DistributorConfig_disturl] ON [dbo].[DISC_DistributorConfig] ([disturl]) ON [PRIMARY]
GO
